Nick Korna
Nick Korna
Reactions
-
Re: Is it possible to have a date counter formula in a sheet?
Hi @autumnleaves, You can absolutely do something like this. If metric is only for current month, you can set this once and not need to update it and wanting today number of days (every day is a trad…1 · -
Re: Week to Week % Complete Progress?
Hi @rmc0030, You could certainly do this with some automation. At a given point (e.g. last thing Friday or first thing Monday), have the rows copied to another sheet. You can then add a column which …1 · -
Re: How do I add days to an existing date?
Hi @Jenna P, If your DATE and Paid off by (est.) columns are both set to date then in the latter put the following formula: =Date@row + [Days rounded up]@row You will need to copy/paste the date into…2 · -
Re: Creating Formulas for Metrics
Your formula is fine, there is just a small error - your LOB criteria is missing a bit of text from the dataset (bolded to make it easy to see): =COUNTIFS({LOB}, HAS(@cell, "Food & Beverage/…1 · -
Re: Cell Reference -1?
If your studies are taking the name from the parent (black coloured) rows, then you can delete the Row ID. You'll still need an extra column for the study name, but can use this instead: =IF(COUNT(CH…1 ·
